Packages are encapsulated collections of related procedures, stored functions, and other program objects stored together in the database. Package bodies, specified subsequently, defines these objects. An package consists of two parts: a specification and a body.
Just simply click ->
Package to open
an object pane for Package. A control-click displays the
popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected package.
Create Package (Package Specification)
To create a new package
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Package from the popup menu.
- Edit package properties on the appropriate tabs of the Package Designer.
To edit the existing package (manage its definition etc)
- Select the package for editing in the object pane.
- Control-click and select the Design
Package from the popup menu or simply double-click the package.
or - Click the
from the object pane toolbar.
- Edit package properties on the appropriate tabs of the Package Designer.
Delete Package
To delete a package
- Select the package for deleting in the object pane.
- Control-click and select the Delete Package
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Create Package Body (Package Body)
To create a new package body
- Select the package for modifying in the object pane.
- Control-click and select Design Package Body from the popup menu.
- Edit package body properties on the appropriate tabs of the Package Body Designer.
To edit the existing package body (manage its definition etc)
- Select the package for editing in the object pane.
- Control-click and select the Design Package Body from the popup menu.
- Edit package body properties on the appropriate tabs of the Package Body Designer.
Run Package
To run a package in the object pane
- Select the package for executing in the object pane.
- Control-click and select Execute Package from the popup menu.
or - Click the Excute from the object pane toolbar.
- View the returned data on the Result tab.
To run a package in the Package Designer
- Create a new package/open the existing package.
- Click
Run.
- View the returned data on the Result tab.
Debug Package
To debug a package
- Select the package for debugging in the object pane.
- Control-click and select the Debug Package from the popup menu.
- Debug the package in the Debugger.
To debug a package in the Package Designer
- Create a new package/open the existing package.
- Click
Debug.
- Debug the package in the Debugger.
Maintain Package
To maintain a package
- Select the package for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Compile
- Compile for Debug
Achieve Package Information
To achieve a package information
- Select the package in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.